package kr.hkit.jenny.coffee;

import java.sql.Connection;
import java.sql.SQLException;

import kr.hkit.jenny.coffee.dao.CoffeeDao;
import kr.hkit.jenny.coffee.dto.SalesRecord;
import kr.hkit.myframework.db.ConnectionFactory;
import kr.hkit.myframework.db.DbUtil;



public class Test {

	public static void main(String[] args) throws SQLException {
//		String filePath = "dbcon.xml";
//		 String driver = "com.mysql.jdbc.Driver";
//		 String url = "jdbc:mysql://localhost:3306/coffee";
//		 String user = "root";
//		 String password = "1111";
//		
//		 DBProperies.savePropertis("dbcon.xml", driver, url, user, password);
//		DBProperies.prnProperties(DBProperies.loadPropertis(filePath));
//
		Connection con = ConnectionFactory.getConnection();

		CoffeeDao dao = new CoffeeDao(con);
		DbUtil.close(con);
	}
}
